# Query Description
# Type of request:                 Extract data from a table
# Name of the selected table:      sophies
# Description of the table:        Spectra (series truncated to the first observation)
# Object:                          HD000400
# Order by:                        ra,seq
# Description of each column
# $link[objname]: ------ Designation of the object
# $j2000: -------------- J2000 coordinates
# $link['S']: ---------- Link to Simbad database
# $link['E']: ---------- <NA>
# seq: ----------------- Sequence number
# $link[slen]: --------- Length of the series
# date: ---------------- Calendar date of observation
# mode: ---------------- Observation mode: High resolution or High efficiency
# fiber_b: ------------- Use of the second fiber (DARK, WAVE or SKY)
# exptime: ------------- exposure time
# sn26: ---------------- Signal/noise in order 26
# $link[view_spec]: ---- <NA>
# $link[view_head]: ---- <NA>
# $link[get_spec]: ----- <NA>
# $link[get_e2ds]: ----- <NA>
# $link[customize]: ---- <NA>
# $link[search_ccf]: --- <NA>
#-------------------- ---------------- --- --- --------------- ---- --------------- --------------- ---- ------ --- --------- --------- -------- -------- --------- ----------
#$link[objname]       $j2000           $li $li seq     $lin date            mode            fibe exptim sn2 $link[vie $link[vie $link[ge $link[ge $link[cus $link[sear
#                                      nk[ nk[         k[sl                                 r_b  e      6   w_spec]   w_head]   t_spec]  t_e2ds]  tomize]   ch_ccf]   
#                                      'S' 'E'         en]                                                                                                            
#                                      ]   ]                                                                                                                          
#-------------------- ---------------- --- --- ------- ---- --------------- --------------- ---- ------ --- --------- --------- -------- -------- --------- ----------
HD000400              J000841.0+363737 S   E    689350    2 2008-09-20 HR WAVE  399.0 159 view_spec view_head get_spec get_e2ds customize search_CCF
HD000400              J000841.0+363737 S   E    689820    2 2008-09-21 HR WAVE  399.0 183 view_spec view_head get_spec get_e2ds customize search_CCF
HD000400              J000841.0+363737 S   E    690530    2 2008-09-23 HR WAVE  665.0 195 view_spec view_head get_spec get_e2ds customize search_CCF
HD000400              J000841.0+363737 S   E    693140    2 2008-09-29 HR WAVE  350.0 191 view_spec view_head get_spec get_e2ds customize search_CCF
HD000400              J000841.0+363737 S   E    693310    2 2008-09-29 HR WAVE  300.0 180 view_spec view_head get_spec get_e2ds customize search_CCF
HD000400              J000841.0+363737 S   E    693450    2 2008-09-29 HR WAVE  300.0 163 view_spec view_head get_spec get_e2ds customize search_CCF
HD000400              J000841.0+363737 S   E    695170    2 2008-10-01 HR WAVE  350.0 169 view_spec view_head get_spec get_e2ds customize search_CCF
HD000400              J000841.0+363737 S   E    830210    2 2009-08-12 HR WAVE  500.0 234 view_spec view_head get_spec get_e2ds customize search_CCF
HD000400              J000841.0+363737 S   E    832700    2 2009-08-15 HR WAVE  300.0 150 view_spec view_head get_spec get_e2ds customize search_CCF
HD000400              J000841.0+363737 S   E    939840    2 2011-10-07 HR WAVE  900.0 122 view_spec view_head get_spec get_e2ds customize search_CCF
HD000400              J000841.0+363737 S   E   1091490    1 2011-01-14 HR DARK  600.0 198 view_spec view_head get_spec get_e2ds customize search_CCF
HD000400              J000841.0+363737 S   E   1227080    2 2011-08-22 HR WAVE  319.0 158 view_spec view_head get_spec get_e2ds customize search_CCF
HD000400              J000841.0+363737 S   E   1229680    2 2011-08-24 HR WAVE  266.0 144 view_spec view_head get_spec get_e2ds customize search_CCF
HD000400              J000841.0+363737 S   E   1244340    2 2011-09-14 HR WAVE  300.0 170 view_spec view_head get_spec get_e2ds customize search_CCF
HD000400              J000841.0+363737 S   E   1245840    2 2011-09-16 HR WAVE  300.0 159 view_spec view_head get_spec get_e2ds customize search_CCF
HD000400              J000841.0+363737 S   E   1475860    1 2012-10-28 HR WAVE 1330.0 212 view_spec view_head get_spec get_e2ds customize search_CCF
HD000400              J000841.0+363737 S   E   1475870    1 2012-10-28 HR WAVE  798.0 180 view_spec view_head get_spec get_e2ds customize search_CCF
HD000400              J000841.0+363737 S   E   1476730    2 2012-10-29 HR WAVE  266.0 146 view_spec view_head get_spec get_e2ds customize search_CCF
HD000400              J000841.0+363737 S   E   1477700    2 2012-10-31 HR WAVE  532.0 213 view_spec view_head get_spec get_e2ds customize search_CCF
HD000400              J000841.0+363737 S   E   1478700    2 2012-11-02 HR WAVE  532.0 259 view_spec view_head get_spec get_e2ds customize search_CCF
#-- end of data table ----------------------------------------------------------
# 20 lines were successfully retrieved